11. Exercise: Math Functions

Exercise: Math Functions

In the exercise below, you'll use SUM and AVERAGE to find the total number of fruit pieces per order and the average number of fruit pieces per order. The data set is very similar to the classroom example, so refer back to the demonstration as needed if you run into problems.

Task Description:

The following list has a series of steps for this exercise. As you complete each step, check it off the list. The quizzes in the task list can be found below.

Task List:

Task Feedback:

Congratulations!

SUM

QUESTION:

What is the formula you used in G7 ? (Include the equal sign in your answer)

SOLUTION:

NOTE: The solutions are expressed in RegEx pattern. Udacity uses these patterns to check the given answer

AVERAGE

QUESTION:

What is the average number of pieces per order?

SOLUTION:

NOTE: The solutions are expressed in RegEx pattern. Udacity uses these patterns to check the given answer